IAD Problem Statement
Consider the Pine Valley Furniture Company database designed and implemented using SQL during the previous semester. This lab aims to develop a web-based solution for the database, incorporating the following functionalities:
- New Customer Registration
- Searching of Products
- Product Selection and Order Placement
- Product Catalog Update
- Payment Provision
The first step involves designing user interfaces for these functionalities, using paper and pencil. Then, we will write HTML to create prototypes for:
- Registration Form
- Product Search Interface
- Order Placement Page
- Catalog Update Page
- Payment System Interface
Links will be created for navigation among the pages, and a menu will be designed using lists and styles. Additionally, help pages will be added for user guidance. You can use a table for layout or opt for a flow-based layout.
Test the user interface prototypes in the browser and experiment with stylesheets.
Help PageMoving Towards Business Intelligence
In this part, we explore how to transform the order processing system into a customer segmentation analysis platform. The following tasks should be considered:
- Apply segmentation analysis to the system.
- Integrate user profiling into the basic order processing system.
- Implement targeted marketing strategies based on the user profiles.
By incorporating business intelligence, we can make data-driven decisions that enhance user experience and optimize marketing efforts.
Question 1: Web-Based Solution for the Project Database
Consider your project database designed and implemented using SQL during the previous semester. You are now required to implement a web-based solution for the database, incorporating the following functionalities:
- Registration of Student/Patient/Passenger/Customer (depending on your project)
- Search facilities, including partial matches
- Additional project-specific functionalities
- Role-based access control
- Payment system (if required)
The first step involves designing the user interfaces for the above functionalities using paper and pencil. Then, write HTML to create the prototypes for:
- Registration Form
- Search Functionality
- Other Project-Specific Features
- Role-Based Access Control Interface
- Payment System Interface (if required)
Links should be created for navigation among these pages, and a menu should be designed using lists and styles. Also, add help pages for user guidance.
Test the user interface prototypes in the browser and experiment with stylesheets.
Question 2: Incorporating Business Intelligence
In order to extend the scope of your project, you are advised to think about how business intelligence can be incorporated into your system. The two key requirements are:
- Applying segmentation analysis within the system.
- Integrating user profiling into the system.
By incorporating these business intelligence aspects, the system can better cater to specific user needs, enhance user experience, and enable more effective decision-making processes.